Universal cache management system

ABSTRACT

Techniques for universal cache management are described. In an example embodiment, a plurality of caches are allocated, in volatile memory of a computing device, to a plurality of data-processing instances, where each one of the plurality of caches is exclusively allocated to a separate one of the plurality of data-processing instances. A common cache is allocated in the volatile memory of the computing device, where the common cache is shared by the plurality of data-processing instances. Each instance of the plurality of data-processing instances is configured to: identify a data block in the particular cache allocated to that instance, where the data block has not been changed since the data block was last persistently written to one or more storage devices; cause the data block to be stored in the common cache; and remove the data block from the particular cache. Data blocks in the common cache are maintained without being persistently written to the one or more storage devices.

TECHNICAL FIELD

The present disclosure relates to memory management in data-processingsystems.

BACKGROUND

The approaches described in this section are approaches that could bepursued, but not necessarily approaches that have been previouslyconceived or pursued. Therefore, unless otherwise indicated, it shouldnot be assumed that any of the approaches described in this sectionqualify as prior art merely by virtue of their inclusion in thissection.

A Symmetric Multi Processor (SMP) machine, or box, is a multiprocessorcomputer host in which two or more Central Processing Units (CPUs), orprocessors, are operatively connected to a single shared physical memoryand are controlled by a single Operating System (OS) instance.Typically, large organizations deploy multiple database instances on thesame SMP host in order to improve utilization and to reduce the totalcost of ownership (TCO). Because of the high TCO of SMP hosts, manyorganizations would like to additionally achieve clustered scalabilityfrom such multi-tenancy deployments of database instances on SMP hosts.Unfortunately, however, clustered multi-tenancy deployments are notwidely used because they suffer from an inability to share physicalmemory among the multiple database instances that run on the same SMPhost.

Specifically, clustered scalability is difficult to achieve inmulti-tenancy deployments because of an over-provisioning of physicalmemory. For example, while an SMP host may have 4-8 CPUs that share oneor more terabytes of physical memory, in typical deployments there maybe twenty or even more database instances that run simultaneously on theSMP host. To address the memory requirements of so many databaseinstances, administrators are typically forced to configure all of theavailable physical memory of the SMP host among the various databaseinstances. However, when one or some of the database instances startexperiencing a heavier workload than the others, it is not possible forthe OS instance on the SMP host to allocate more physical memory tothese database instances because all of the physical memory of the SMPhost has already been provisioned. In order to address thisover-provisioning problem, administrators typically have to shut downone or several database instances that are not busy at the time, so thatthe OS instance on the SMP host can re-provision the released physicalmemory to the database instances that are experiencing the heavyworkloads. Needless to say, this solution is not only inefficientbecause it involves intervention by administrators, but it also lacksthe consolidation desired from the multi-tenancy deployment on the SMPhost because when database instances are shut down they are notavailable for failover and any other availability purposes. Further,under such multi-tenancy deployments, it is clear that the problem ofmemory over-provisioning is a serious obstacle to achieving realscalability by deploying multiple database instances in one or moreclusters.

While the problem of memory over-provisioning is described above withrespect to database instances that are deployed on SMP hosts, it isnoted that this problem is not unique to SMP hosts or to databaseinstances. Rather, the same memory over-provisioning problem may beexperienced in multi-tenancy deployments on smaller commodity servermachines for any type of data-processing instances that use a lot ofvolatile memory to buffer data from persistent storage in order toaccess and modify the data before writing it back to the persistentstorage.

BRIEF DESCRIPTION OF THE DRAWINGS

The techniques described herein are illustrated by way of example, andnot by way of limitation, in the figures of the accompanying drawingsand in which like reference numerals refer to similar elements and inwhich:

FIG. 1 is a flow diagram that illustrates an example method for cachemanagement according to one embodiment;

FIG. 2 is a block diagram that illustrates an example operationalcontext according to one embodiment;

FIG. 3 is a block diagram that illustrates another example operationalcontext according to one embodiment; and

FIG. 4 is a block diagram that illustrates an example computing deviceon which embodiments may be implemented.

DETAILED DESCRIPTION

In the following description, for the purposes of explanation, numerousspecific details are set forth in order to provide a thoroughunderstanding of the described techniques for automatic data placement.It will be apparent, however, that the techniques described herein maybe practiced without these specific details. In other instances,well-known structures and devices are shown in block diagram form inorder to avoid unnecessarily obscuring the techniques described herein.

General Overview

Techniques for universal cache management are described herein. Each ofmultiple data-processing instances executing on a computing device isallocated an exclusive, private cache in the volatile memory of thecomputing device. In such multi-tenancy deployment of data-processinginstances on the computing device, each data-processing instance usesits private cache to buffer data items that are persistently stored onone or more persistent storage devices, where the data-processinginstance accesses, modifies, and/or otherwise processes the data itemsin the private cache before persistently writing the data items from theprivate cache back to the persistent storage device(s).

According to the techniques described herein, a common cache isallocated in the volatile memory of the computing device such that thecommon cache can be shared by the multiple data-processing instancesthat run on the computing device. When any given data-processinginstance needs space in its private cache to read one or more additionaldata items from the persistent storage device(s), the data-processinginstance identifies for eviction a “clean” data item in its privatecache—e.g., such as a data item that has not been modified in theprivate cache since the data item was last written from the privatecache to the persistent storage device(s). Instead of just discardingthe clean data item from its private cache, the data-processing instancestores, or causes the clean data item to be stored, in the common cache.After the clean data item has been stored in the common cache, thedata-processing instance removes the clean data item from its privatecache in order to free up space for storing the additional data item(s)that need to be read from the persistent storage device(s). Thereafter,when the data-processing item needs to read into its private cache theclean data item, the data-processing instance first checks in the commoncache to determine whether the clean data item is still storedtherein—and if it is, the data-processing instance retrieves the cleandata item from the common cache instead of reading it from thepersistent storage device(s).

In this way, the common cache effectively serves as a universal cacheresource pool that maintains clean data items in volatile memory formultiple data-processing instances. The common cache is effectivelyshared among all data-processing instances without being exclusivelyallocated to any one instance; thus, if a particular instance becomesmore active, that particular instance will consume more of the commoncache than other instances without any availability impact to the otherinstances—which do not need to be taken down, but at most would need tofetch from the persistent storage device(s) those data items that arenot found in the common cache. In this manner, the techniques describedherein: (1) avoid the shutting down of data-processing instances inorder to re-provision their memory to other, busier instances; (2) avoidthe problem of memory over-provisioning and allow data-processinginstances on the computing device to be configured in a cluster withouthaving to face frequent memory re-provisioning.

In an example embodiment, the techniques described include a methodperformed by a computing device that comprises: allocating, in volatilememory of the computing device, a first cache exclusively to a firstinstance of two or more data-processing instances, where the first cacheis configured to store copies of a first set of data blocks that arepersistently stored on one or more storage devices; allocating, in thevolatile memory of the computing device, a second cache exclusively to asecond instance of the two or more data-processing instances, where thesecond cache is configured to store copies of a second set of datablocks that are persistently stored on the one or more storage devices;allocating a common cache in the volatile memory of the computingdevice; the first instance performing the steps of: identifying, in thefirst cache, a first data block that has not been changed since thefirst data block was last written to the one or more storage devices;causing the first data block to be stored in the common cache; removingthe first data block from the first cache; the second instanceperforming the steps of: identifying, in the second cache, a second datablock that has not been changed since the second data block was lastwritten to the one or more storage devices; causing the second datablock to be stored in the common cache; removing the second data blockfrom the second cache; and maintaining data blocks, including the firstdata block and the second data block, in the common cache withoutpersistently writing the data blocks to the one or more storage devices.

In another example embodiment, the techniques described herein may beimplemented as a method performed by a computing device that comprises:allocating, in volatile memory of the computing device, a plurality ofcaches to a plurality of database instances, where each one of theplurality of caches is exclusively allocated to a separate one of theplurality of database instances; allocating, in the volatile memory ofthe computing device, a common cache that is shared by the plurality ofdatabase instances; each particular database instance performing thesteps of: identifying a particular data block in a particular cache, ofthe plurality of caches, that is exclusively allocated to the particulardatabase instance, where the particular data block has not been changedin the particular cache since the particular data block was lastpersistently written to one or more storage devices; causing theparticular data block to be stored in the common cache; removing theparticular data block from the particular cache; and maintaining datablocks, including the particular data block, in the common cache withoutpersistently writing the data blocks to the one or more storage devices.

In various other embodiments, the techniques described herein may beimplemented as one or more computer program products in the form ofsequences of executable instructions that are stored on one or morecomputer-readable storage media, and/or as one or more systems that areconfigured to perform the methods described above.

Functional Description of an Example Embodiment

FIG. 1 is a flow diagram that illustrates an example method foruniversal cache management in accordance with the techniques describedherein. In some embodiments, the steps of the method illustrated in FIG.1 are performed by one or more processes that are executing on acomputing device as part of one or more data-processing instances. Asused herein, “instance” refers to an allocated chunk of memory and a setof one or more processes, associated with that chunk of memory, that areallocated computational resources such as memory, CPU time, and/or diskstorage space in order to perform one or more functionalities. Anexample of a process that may be included in an instance is a “server”(also referred to herein as a “server process”) that is configured torespond to requests from various clients and applications for one ormore services and/or functionalities.

As used herein, “data-processing instance” refers to an instance that isallocated an exclusive cache in the volatile memory of a computingdevice for buffering data blocks that are persistently stored on one ormore storage devices, where the data-processing instance accesses,modifies, and/or otherwise processes the data blocks in its exclusivecache before persistently writing the data blocks from its exclusivecache back to the storage device(s). As used herein, “exclusive” or“private” cache refers to a cache that is accessible by only onedata-processing instance and that cannot be accessed by, or shared with,other data-processing instances. Examples of data-processing instancesinclude without limitation database instances that manage data in one ormore databases, multimedia server instances that manage various types ofmultimedia such as images, audio/video streams, and other streamedmultimedia content, internet server instances that cache content that ispersistently stored elsewhere, application server instances and othertypes of middleware server instances that cache data to serviceparticular types of clients and applications, and any other types ofinstances that are configured to process persistently stored data bybuffering it into a volatile memory cache.

As used herein, “data block” refers to a unit (e.g., such as a datastructure) that is allocated in persistent storage to store a portion ofdata that is managed by a data-processing instance. It is noted that, asused herein, a data block is a unit of data that is persistently storedon one or more storage device(s) and that survives restarts of thedata-processing instance; thus, a data block is different from thevarious dynamic and static configuration parameters of thedata-processing instance and from the various run-time attributes,variables, handles, and other process context information that ismaintained by the data-processing instance in the volatile memory of thecomputing device during the instance's run-time operation.

The method illustrated in FIG. 1 is described hereinafter as beingperformed by one or more instances (or processes thereof) such as an OSinstance and/or data-processing instances. However, it is noted thatthis description is for illustrative purposes only and the method ofFIG. 1 is not limited to being performed by any particular type ofinstance or computer process.

In step 102, a first cache is exclusively allocated in the volatilememory of a computing device to a first instance of two or moredata-processing instances that are executing on the computing device.The first cache is configured to store copies of a set of data blocksthat are persistently stored on one or more storage devices. Forexample, in some implementations, an OS instance on the computing devicemay allocate a portion (e.g., such as a range of memory addresses) ofvolatile memory to the first data-processing instance. Then, thesoftware component from which the first instance is instantiated and/ora process in the first instance may allocate this portion of memoryamong the first cache and the processes that comprise the firstinstance. In another example, the OS instance on the computing devicemay perform the actual allocation of memory to the first cache and toeach of the processes included in the first data-processing instance.Thus, the techniques described herein are not limited to having aspecific type of a component that allocates memory for the exclusivecache of the first data-processing instance.

In a similar manner, in step 104 a second cache is exclusively allocatedin the volatile memory of the same computing device to a second instanceof the two or more data-processing instances that are executing on thecomputing device. The second cache is configured to store copies of aset of data blocks that are persistently stored on one or more storagedevices, where this set of data blocks may be the same or different thanthe set of data blocks which are processed by the first data-processinginstance.

In step 106, a common cache is allocated in the volatile memory of thecomputing device. The common cache is allocated in such manner that atleast some (and possibly all) of the two or more data-processinginstances running on the computing device can share the common cache bystoring clean data blocks therein. According to the techniques describedherein, the common cache may be allocated by various types of processesand instances. For example, in some implementations, the common cachemay be allocated as a shared range of memory addresses by the OSinstance that executes on the computing device. In otherimplementations, the OS instance may allocate a portion of memory to acommon cache instance. Then, the software component from which thecommon cache instance is instantiated and/or a process in the commoncache instance may allocate this portion of memory among the commoncache and the processes that comprise the common cache instance.

According to the techniques described herein, in various embodiments andimplementations the common cache may be allocated in the physical memoryof the computing device, on flash memory card(s) that are attached tothe computing device, and/or in a combination of the physical memory andthe flash memory card(s) of the computing device such that a portion ofthe common cache resides in the physical memory and a spill-over portionresides on the flash memory card(s)

In step 108A, the first instance of the two or more data-processinginstances identifies a clean first data block in the first cache, whichis exclusively allocated to the first instance. As used herein, “clean”data block refers to a data block stored in a cache, where the datablock that has not been modified in the cache since the data block waslast written (or flushed) from the cache to persistent storage.

In step 110A, the first instance causes the identified clean data blockto be stored in the common cache. For example, in some implementationsthe first instance or a process thereof stores the clean data block inthe common cache; in other implementations, the first instance or aprocess thereof sends the clean data block to a common cache instancethat manages the common cache, and the common cache instance or aprocess thereof stores the clean data block in the common cache andreturns an acknowledgement to the first instance.

After the clean data block is stored in the common cache, in step 112Athe first instance or a process thereof removes (or “purges”) the cleandata block from the first cache allocated to the first instance withoutwriting the clean data block to the storage device(s). For example, thefirst instance or the process thereof may remove the clean data block inorder to free space for storing another data block that needs to be readfrom the storage device(s) into the first cache.

The second data-processing instance processes its clean data blocks in asimilar manner—e.g., instead of just discarding clean data blocks inorder to free space in its exclusive cache, the second instance firstcauses its clean data blocks to be stored in the common cache. Forexample, in step 108B, the second instance or a process thereofidentifies a clean second data block in the second cache, which isexclusively allocated to the second instance. Then, in step 110B, thesecond instance or the process thereof causes the identified clean datablock to be stored in the common cache, for example by storing the cleandata block directly into the common cache or by sending the clean datablock to the common cache instance that manages the common cache. Afterthe clean data block is stored in the common cache, in step 112B thesecond data-processing instance or a process thereof removes the cleandata block from its exclusive cache without flushing the clean datablock to the storage device(s).

According to the techniques described herein, in step 114 the datablocks in the common cache are maintained without being written (orflushed) back to the storage device(s) where the data blocks arepersistently stored. For example, when space needs to be freed in thecommon cache, a process that manages the common cache can use variouscache management mechanisms to identify and page out data blocks fromthe common cache, where such cache mechanisms may include, withoutlimitation, Least Recently Used (LRU) mechanisms, Most Recently Used(MRU) mechanisms, Least Frequently Used (LFU) mechanisms, touch-upmechanisms, and/or various combinations and modifications thereof.According to the techniques described herein, the instance and/or theprocess(es) that manage the common cache do not modify or otherwisechange the contents of the data blocks stored in the common cache and,since the data blocks in the common cache are clean, does not need topersistently write these data blocks back to the storage device(s).

When a data-processing instance (e.g., such as the first instance or thesecond instance) of the two or more data-processing instances needs toread a data block into its exclusive cache, the data-processing instancefirst checks to determine whether the data block in question is storedin the common cache. If the data block in question is stored in thecommon cache, then the data-processing instance reads or causes the datablock to be read from the common cache instead of the storage device(s),thereby saving one or more Input/Output (I/O) operations to the storagedevice(s). If the data block in question is not stored in the commoncache (either because the data block has not yet been stored in thecommon cache or has been paged out from there), the data-processinginstance causes the data block to be retrieved from the storagedevice(s). In some implementations, causing the data block to beretrieved from the storage device(s) involves the data-processinginstance itself fetching the data block from the storage device(s). Inother implementations, in response to a cache miss for the data block inthe common cache, an instance that manages the common cache retrievesthe data block from the storage device(s) and returns it to thedata-processing instance. In operational contexts that use a cluster ofcommon caches, in response to a cache miss the instance that manages thelocal common cache can fetch the data block from another cache in thecommon cache cluster instead of retrieving the data block from thestorage device(s).

In this manner, the techniques for universal cache management describedherein avoid the problem of memory over-provisioning in multi-tenancydeployments. In addition, the use of the common cache as describedherein allows data-processing instances on the same computing device tobe configured in scalable cluster(s) without memory re-provisioningissues, while at the same time providing support for variousavailability functions (e.g., such as instant failover, mission-criticallevel of performance, etc.) that may be required of the particularmulti-tenancy deployment.

Block-Identifying Data

According to the techniques described herein, block-identifying data ismaintained for data blocks that are stored in a common cache that isallocated in the volatile memory of a computing device and is shared bymultiple data-processing. As used herein, “block-identifying data”refers to one or more values that identify data blocks that are storedin the common cache. In various embodiments, the block-identifying datamay include various types of identifiers and may be maintained byvarious entities in various types of data structures.

For example, in various embodiments the block-indentifying data for agiven data block may include, without limitation, any suitable blockidentifier(s) such as: a system-wide block identifier that uniquelyidentifies the data block; a combination of one or more storageidentifiers (e.g., such as disk ID, file ID, etc) and one or more blockidentifiers (e.g., such as a block ID, file offset, etc.), where thecombination uniquely identifies the data block to any of thedata-processing instances that share the common cache on a computingdevice; one or more version identifiers that indicate whether a datablock is current or not, where the version identifier(s) may beassociated specifically with the individual data block or with a set ofdata blocks that are modified at the same time or in the sametransaction; and any other types of block identifiers and/or combinationof block identifiers that are suitable to identify data blocks todata-processing instances that execute on a computing device.

In various embodiments the block-identifying data, for data blocksstored in the common cache on a computing device, may be maintained inany suitable types of data structures that may be allocated in thevolatile memory of the computing device and/or in some combination ofvolatile memory and persistent storage. For example, in some embodimentsthe block-identifying data may be maintained in a data directory orother suitable data repository that is maintained in the volatile memoryof the computing device that hosts the common cache. In otherembodiments, the block-identifying data may be maintained both in thecommon cache and in the private caches of the data-processing instancesthat share the common cache. For example, in these embodiments aninstance, which manages the common cache, may assign a unique block IDto each data block as the data block is stored in the common cache andmay return this block ID to the data-processing instance that caused thedata block to be stored in the common cache; upon receipt of this blockID, the data-processing instance associates or maps this block ID toother block-identifying data it maintains for the data block and usesthis block ID to request the data block from the common cache. It isnoted that the techniques described herein are not limited to anyparticular type of storage for storing block-identifying data, and thusthe examples described herein are to be regarded in an illustrativerather than a restrictive sense.

In various embodiments, various types of instances and processes may beused to maintain the block-identifying data for data blocks that areaccessed by multiple data-processing instances that share a common cacheon the same computing device. For example, in some embodiments theblock-identifying data may be maintained by an instance or a processthereof that is dedicated on the computing device to tracking datablocks for the data-processing instances and the common cache. In otherembodiments, the block-identifying data may be maintained by both theinstance that manages the common cache and the data-processing instancesthat store data blocks in the common cache. In yet other embodiments inwhich the common caches on multiple computing devices are configured ina cluster, a distributed cluster-ware process(es) may be used tomaintain the block-identifying data for all data blocks that can bestored in any of the common caches that are configured in the cluster.It is noted that the techniques described herein are not limited tousing a particular type of instance or process to maintainblock-identifying data, and thus the examples described herein are to beregarded in an illustrative rather than a restrictive sense.

Example Operational Context

An example embodiment of the techniques for universal cache managementdescribed herein may be implemented for multiple database instances thatare deployed on the same computing device.

As used herein, “database instance” refers to an instance that manages adatabase. “Database” refers to a collection of data that is stored onone or more persistent storage devices. In various embodiments andimplementations, the collection of data comprising a database may bestored on the persistent storage device(s) as one or more data filesthat store the data of various database objects, one or more log filesthat store log data necessary to maintain consistent transactionprocessing and recovery, and one or more control and configuration filesthat store the control and configuration data associated with thedatabase.

In the context of database instances, a data block is an atomic unit(e.g., such as a data structure) that is allocated in persistent storageto store one or more data rows (and/or portions thereof) that includedata associated with one or more database objects of a database. In someembodiments, all data blocks processed by a database instance may havethe same fixed size; in other embodiments, the data blocks processed bya database instance may have variable sizes. In various embodiments, thedatabase instance is typically configured to write and read data to andfrom volatile memory in units no smaller than data blocks. For example,when the database instance needs to access the data in a particular datarow or a group of data rows, the database instance or a process thereofdetermines the data block(s) which physically store the particular datarow or the group of data rows, copies these data blocks(s) from thepersistent storage into the private memory cache of the databaseinstance if these data block(s) are not already in the cache, andaccesses the data in the particular data row or the group of data rowsin the copies of the data block(s) that are stored in the private memorycache. The database instance or a process thereof may use various memorymanagement mechanisms to flush any modified (also referred to as“dirty”) data blocks from the private memory cache to the persistentstorage.

In various embodiments and implementations, the data blocks which storethe data of a given database may be logically organized in variousstorage space structures (e.g., such as extents, segments, tablespaces,etc.) and may be physically allocated as raw hard disk blocks or asportions of Operating System (OS) data files. For example, the data of adatabase (e.g., such as relational or object-relational database) islogically organized in database objects (sometimes also referred to as“schema objects”) that may include, but are not limited to, tables,views, sequences, stored procedures, indexes, and database links toother databases. Physically, the data of a database is stored onpersistent storage device(s) in data blocks, where in variousembodiments and implementations such data blocks may be physicallystored as raw disk blocks directly on the persistent storage device(s)or may be stored in files that are stored on the persistent storeddevice(s). Depending on the number and data types of the data valuesthat are stored in the data rows, a particular data block may store thedata values from a single data row or may store the data values frommultiple data rows, where the multiple data rows may logically belong tothe same database object or to multiple different database objects. Asan example, the data of a relational table may be logically organized inrecords, where each record includes one or more fields for storing datavalues from the corresponding one or more columns that are configuredfor the table. Physically, the data values in each data record may bestored as a data row in one or more data blocks that are stored in afile on a persistent storage device such as a hard disk. For example, ina relational table that stores employee data in three columns named“ID”, “first_name”, and “last_name”, a particular data row can storevalues for an employee ID, a first name, and a last name for aparticular employee.

In a multi-tenancy deployment, the same database may be accessed bymultiple database instances that are configured as a cluster on one ormore computing devices. In such multi-tenancy deployment, it is notuncommon to configure several (5, 10, even 20) database instances to runon the same computing device, which is typically an SMP machine (orhost). A conventional approach to address the memory requirements insuch multi-tenancy deployment is for administrators to allocate a smallportion of volatile memory to the private buffer cache of each databaseinstance, and to allocate the rest of the volatile memory of the SMPhost to the file buffer cache that is managed by the OS instance on theSMP host. The OS instance on the SMP host uses the file buffer cache tocache file blocks from files that are stored in one or more file systemsmanaged by the OS instance and that are accessed via I/O system calls bythe database instances and by other processes that run on the SMP host.

The main disadvantage of this conventional approach is that the OSinstance treats the file blocks in the file buffer cache as opaque data.For example, while the OS instance or an I/O process thereof may keepsome minimal metadata so that it can provide read and write access tothe file blocks in the file buffer cache, the OS instance or the I/Oprocess thereof does not know and does not keep track of how thedatabase instances use the file blocks in the file buffer cache. Rather,the OS instance associates each file block in the file buffer cache withthe OS-process ID of the database instance process that placed the fileblock in the file buffer cache. This effectively prevents a databaseinstance from accessing a file block that has been placed in the filebuffer cache by a different database instance. In addition, when adatabase instance process dies, for correctness reasons all file blocksplaced by that process in the file buffer cache are purged—the OS I/Oprocess writes these file blocks to disk if they are dirty or justthrows them out if they are clean. The reason for this is that the OSinstance cannot guarantee that when a process restarts it will beassigned the same process ID; hence, for correctness reasons, the OSinstance must purge from the file buffer cache any file blocks that havebeen placed there by a process that has died. In practical terms, thismeans that when a database instance restarts, it will not find in thefile buffer cache any file blocks that have been placed there by thedatabase instance processes.

To address these and other problems of multi-tenancy deployments ofdatabase instances (e.g., such as memory over-provisioning problems,limited scalability, and restricted availability), the techniquesdescribed herein provide for allocating and managing a common cache onthe computing device at a layer above the OS instance, whereblock-identifying data is maintained for data blocks stored in thecommon cache in order to provide visibility into the use of the datablocks by the multiple database instances that share the common cache.

FIG. 2 is a block diagram that illustrates an example operationalcontext according to one embodiment. Computing device 202 iscommunicatively connected to storage devices 215 over network 200.Storage devices 215 include one or more non-volatile storage mediumdevices such optical or magnetic disks 215A, 215B, and 215C. Network 200may be a storage area network (SAN) or network area storage (NAS) thatincludes one or more network infrastructure elements (e.g., such asbridges, switches, routers, etc.) that are configured to transferdisk-level and/or file-level data between computing devices and storagedevices.

Computing device 202 is a computer system that is configured to executean OS instance (not shown in FIG. 2). Depending on the particulardeployment, a computing device may be a separate machine host or a bladethereof that is configured with various hardware components such asprocessors (CPUs), memory, storage controller(s), network interfacecard(s), etc. As illustrated in FIG. 2, computing device 202 comprisesvolatile memory 204. Volatile memory 204 may include physical memory,flash memory on one or more flash memory cards that are attached tocomputing device 202, and/or a combination thereof.

Multiple database instances 206 are configured to execute on computingdevice 202. Database instances 206 manage one or more databases that arestored across network 200 on storage devices 215. Each of databaseinstances 206 comprises a chunk (or portion) of volatile memory 204 anda set of one or more processes that are allocated computationalresources such as memory, CPU time, and/or disk storage space in orderto perform one or more functionalities. For example, the set ofprocesses included in each of database instances 206 may include,without limitation, one or more database writer processes, one or morelog writer processes, one or more checkpoint processes, and one or moredatabase server processes. (It is noted that in a differentimplementation, the functionalities performed by the database writerprocess(es), the log writer process(es), the checkpoint process(es), andthe database server process(es) may be performed by a single, possiblymulti-threaded process that is collectively referred to as a databaseserver.)

A database writer process is configured to flush “dirty” data blocksfrom the private cache of the database instance to the data files on thepersistent storage device(s) that store the data of the database managedby the database instance. A log writer process is configured to write tolog files on the persistent storage device(s) redo and/or undoinformation that is used to maintain consistent transaction processingand recovery of the database managed by the database instance. Acheckpoint process is configured to write to the log files and/or thedata files a checkpoint, which is a data structure that stores a systemchange number (SCN) which indicates that all changes made to data blocksprior to recording the checkpoint have been written to the persistentstorage device(s).

A database server process (or a “database server”) is allocatedcomputational resources such as memory and CPU time in order to performone or more functionalities such as data management functions(including, but not limited to, reading data blocks from the persistentstorage device(s) into the private cache of the database instance,processing requests and queries by clients and applications to performvarious operations and transactions that read, insert, delete, andmodify data in the data blocks stored in the private cache of thedatabase instance), as well as database management functions (including,but not limited to, processing queries and requests to create databasesand tables, to allocate disk space for databases and tables, and/or tocreate and maintain user login information, role information, andsecurity policy information).

As illustrated in FIG. 2, database instance 206A is allocated a portionof volatile memory 204 for its exclusive private cache 210A. Databaseinstance 206A includes process(es) 208A such as, for example, one ormore database writer processes, one or more log writer processes, one ormore checkpoint processes, and one or more database server processes.One or more of process(es) 208A maintains lock structures 212A in thevolatile memory allocated to database instance 206A, where for each datablock stored in private cache 210A lock structures 212A include a lockstructure that is used to control access to that data block in cache210A.

Similarly, database instance 206B is allocated a portion of volatilememory 204 for its exclusive private cache 210B. Database instance 206Bincludes process(es) 208B such as, for example, database writerprocess(es), log writer process(es), checkpoint process(es), anddatabase server process(es). One or more of process(es) 208B maintainslock structures 212B in the volatile memory allocated to databaseinstance 206B, where for each data block stored in private cache 210Block structures 212B include a lock structure that is used to controlaccess to that data block in cache 210B.

According to the techniques for universal cache management describedherein, a portion of volatile memory 204 is allocated to common cache220. A portion of volatile memory 204 is also allocated to blockmetadata 222, which stores block-identifying data for the data blocksstored in common cache 220. One or more processes 224 are allocatedmemory and other computing resources (e.g., CPU time) to manage commoncache 220 and block metadata 222. As illustrated in FIG. 2, a singleinstance 230 may be instantiated from a software component stored in acomputer-readable storage medium where, when executed, the softwarecomponent may allocate memory to, and otherwise configure, common cache220, block metadata 222, and process(es) 224. It is noted, however, thatin different embodiments and implementations, the common cache and blockmetadata may be managed by one or more processes that are initializedfor different instances that each performs different functionalities.Thus, the use of a single instance 230 in the operational context ofFIG. 2 is to be regarded in an illustrative rather than a restrictivesense.

In the operational context of FIG. 2, instance 230 may be a storagemanagement instance which manages common cache 230 in addition toperforming storage volume management for database instances 206 that areconfigured to execute on computing device 202. For storage volumemanagement, when a database instance wants to create a new data file tostore data for a given database, the database instance requests frominstance 230 to create the data file on a group of disks. From theperspective of instance 230, the data file is a logical address spacethat is allocated to data blocks that store data for the database.Instance 230 maps the logical address space of the data file to physicalstorage areas on the different disks in the disk group—e.g., the datafile may have a total of 100 MB of storage space that is mapped to 100chunks of 1 MB, where each chink is stored on a particular disk of thedisk group. After creating and mapping the data file in this manner,instance 230 returns an extent map to the database instance, where theextent map describes the mapping from the logical address space of thedata file to the physical storage areas on the disks in the disk group.Thus, when the database instance wants to persistently store a datablock on disk, the database instance determines the logical address ofthe data block within the data file, uses the extent map to translatethis logical address into the physical disk address on the correspondingdisk (e.g., such as “disk1”, offset 500), and writes the data block tothe location on the disk that is pointed to by that physical diskaddress.

According to the techniques described herein, instance 230 or a processthereof may manage common cache 220 by organizing the volatile memoryallocated to the common cache into a memory group that is mapped to arange of memory addresses, where the data blocks from database instances206 are stored at different offsets within that range. Since the datablocks stored in common cache 220 are always clean, instance 230 canmaintain common cache 220 without persistently writing data blocks fromthe common cache to storage devices 215 and without allowing anymodifications to be made to the data in the data blocks while the datablocks are stored in the common cache. Further, instance 230 may use anyknown cache management mechanism (e.g., such LRU, MRU, LFU, etc.) todetermine and discard (or page out) data blocks from common cache 230when a database instance needs space in the common cache to store a datablock.

In operation, database instance 206A stores in its private cache 210Acopies of the data blocks for the database (not shown in FIG. 2) that ismanaged by the database instance. (It is noted that in FIG. 2, theshaded areas in caches 210A and 210B represent “dirty” data blocks thathave been modified in these caches since the last time these data blockshave been written to storage devices 215.) When database instance 206Aneeds to free up space in cache 210A, according to the techniquesdescribed herein the database instance or a process thereof firstidentifies a clean data block that can be removed from cache 210A, wherethe clean data block has not been modified in cache 210A since it waslast written to storage devices 215. Database instance 206A or theprocess thereof may use any suitable cache management mechanism toselect clean data blocks that can be removed from cache; it is noted,however, that according to the techniques described herein dirty datablocks are not selected for removal. As illustrated in FIG. 2, cleandata blocks 45 and 37 may be selected in this manner for removal fromcache 210A. (It is noted that in FIG. 2, the block identifiers “45”,“37”, “56”, “28”, etc., are used for illustration purposes only; in areal implementation, the data blocks may be identified in any suitablemanner—e.g., such as using a combination of a file ID and block ID orfile offset).

After selecting a data block, e.g., such as data block 45, for removal,database instance 206A or a process thereof retrieves the lockincarnation number for this data block from the lock structure 212Acorresponding to this data block. The lock incarnation number for a datablock is a value that is incremented each time the data block ismodified; thus, the lock incarnation number for a data block effectivelyindicates whether the copy of the data block associated with that lockincarnation number is the most current or not. After retrieving the lockincarnation number for the selected data block 45, database instance206A sends this data block and its lock incarnation number to instance230. Instance 230 or a process thereof writes data block 45 into commoncache 220. As part of the write operation, instance 230 or the processthereof also records the lock incarnation number for data block 45 intothe block metadata 222 that is associated with that data block. Uponsuccessfully committing the write operation for data block 45, instance230 or the process thereof returns to database instance 206A a commoncache ID for data block 45. The common cache ID for data block 45uniquely identifies, within common cache 220, data block 45 and the lockincarnation number thereof that was recorded in block metadata 222. Uponreceiving the common cache ID for data block 45, database instance 206Aor a process thereof records the common cache ID into the lock structure212A that is associated with data block 45 and then removes data block45 from private cache 210A. It is noted that database instance 206Akeeps the lock structure 212A for data block 45 in memory even thoughdata block 45 has been removed from private cache 210A.

At a later point in time, when database instance 206A needs access tothe data in data block 45, the database instance or a process thereoffirst check to determine whether the data block is stored in commoncache 220. To do this, database instance 206A or a process thereofretrieves the common cache ID and the lock incarnation number from thelock structure 212A that is associated with data block 45, and sends theretrieved common cache ID and lock incarnation number to instance 230.Instance 230 or a process thereof uses the common cache ID and the lockincarnation number to determine whether a data block associated withthese values is stored in common cache 220. If it is determined that thecommon cache stores a data block that is associated with the receivedcommon cache ID and with the received (or a higher) lock incarnationnumber, then instance 230 or the process thereof retrieves this datablock from common cache 220 and returns it to database instance 206A. Ifit is determined that common cache 220 does not store a data block thatis associated with the received common cache ID, or if the received lockincarnation number indicates that the data block stored in common cache220 is old, then instance 230 or the process thereof returns a cachemiss indication to database instance 206A and discards from common cache220 the data block that is associated with the received common cache IDand with the old lock incarnation number. Upon receipt of a cache missindication from instance 230, database instance 206A or a processthereof proceeds to read the requested data block (data block 45) fromstorage devices 215.

According to the techniques described herein, all of database instances206 process data blocks that are stored in their corresponding privatecaches in the same manner as described above. For example, databaseinstance 206A processes data block 37 in the same manner as it processeddata block 45. In another example, database instance 206B processes datablocks 56 and 28 in the same manner as database instance 206A processeddata block 45. This ensures that multiple database instances can usecommon cache 220 as a shared memory pool that stores clean data blocks.In addition, this allows a database instance to retrieve from commoncache 220 data blocks that are stored there by a different databaseinstance. For example, suppose that database instances 206A and 206B areconfigured to manage the same database. In this operational scenario,when database instance 206A needs access to data in data block 56,database instance 206A or a process thereof can retrieve data block 56from common cache 220 instead of retrieving this data block from storagedevices 215.

Different embodiments of the techniques described herein may usedifferent types of information to ensure that an old version or copy ofa data block is not going to be returned from the common cache. Asdescribed heretofore, a database instance keeps a lock incarnationnumber in the lock structure for a data block even after the data blockis removed from the private cache of the database instance, where thelock incarnation number is typically flushed to disk along with the datablock. This ensures that if a different database instance (that managesthe same database on the same or a different computing device) retrievesthe same data block from the persistent storage device(s) and modifiesit, a different (e.g., higher) lock incarnation number will beassociated with the most current copy of the data block, therebypreventing the common cache (or the process that manages it) fromreturning to the first database instance the old copy of the data blockthat is stored in the common cache.

In some embodiments, in addition to a common cache ID that identifies adata block that has been successfully committed to the common cache, theprocess managing the common cache may return to a database instance asystem change number (SCN) that is associated with the data block. TheSCN for a database is incremented and recorded in persistent storage inresponse to a checkpoint, and indicates that all changes made to datablocks of the database prior to recording the checkpoint have beenwritten to the persistent storage. Since the sequence of SCNs for agiven database is known to the database instance(s) that manage thatdatabase, by associating a copy of a data block stored in the commoncache with the current SCN for the database, the process managing thecommon cache ensures that a database instance will not be sent an oldcopy of a data block from the common cache.

In the above manner, the techniques described herein address variousproblems (e.g., such as memory over-provisioning problems, limitedscalability, and restricted availability, etc.) that arise in thecontext of multi-tenancy deployments of database instances on the samecomputing device or host. Specifically, the techniques described hereinallow administrators to instantiate or otherwise configure each databaseinstance on the computing device with a private buffer cache that isjust big enough to hold the maximum anticipated number of dirty datablocks, which avoids the problem of over-provisioning volatile memorywhen multiple database instances are deployed on the same computingdevice. The rest of the volatile memory on the computing device (likelya big chunk if the computing device is an SMP host) is allocated to thecommon cache. In this manner, a database instance would have enoughspace in its private cache for its own dirty data blocks, while itsclean data blocks will be kept in the common cache. The technical effectof this would be that the common resource in contention (the volatilememory on the computing device) is effectively and dynamically sharedamong all database instances that execute on the computing device. If aparticular database instance becomes more active and experiences aheavier workload, then this particular database instance will consumemore of the common cache without causing any adverse availability impactto the other database instances—which do not need to be taken down bythe administrators, but at most would need to fetch data blocks from thepersistent storage for the period of time when the particular databaseinstance is experiencing the heavier workload. In addition, by allowingmultiple database instances to dynamically use variable chunks of thevolatile memory of the computing device based on workload, thetechniques described herein allow the database instances to be deployedas a cluster that is truly scalable.

Use Case: Integrating Multiple Common Caches into a Cluster

In some operational contexts, the techniques for universal cachemanagement described herein provide for integrating, into a cluster,multiple common caches that are allocated on multiple computing devices.In an example embodiment in such operational context, in response toreceiving a request for a data block and failing to find the data blockin its common cache, a process managing the common cache determineswhether another common cache in the cluster stores the data block and,if so, requests the data block from the other common cache. Thetechnical effect of this would be a common cache cluster that can bevery large in size, which greatly increases the chances that at anygiven time any given database instance, which is configured to storedata blocks in any given common cache of the cluster, will be able tofind a data block it needs in at least one of the common cachescomprising the cluster, thereby obviating the need to perform I/Ooperations to fetch this data block from persistent storage.

FIG. 3 is a block diagram that illustrates an example embodimentaccording to such operational context. Computing devices 302 arecommunicatively connected over a network (not shown in FIG. 3). Each ofcomputing devices 302 may be a separate machine host or a blade thereofthat is configured with various hardware components such as processors(CPUs), memory, storage controller(s), network interface card(s), etc.

According to the techniques described herein, each of computing devices302 comprises one or more database instances and a common cacheinstance, where the common cache instance includes a portion of volatilememory allocated to a common cache and a set of one or more processesthat are configured to manage the common cache. For example, computingdevice 302A comprises database instances 304A and common cache instance306A, and computing device 302B comprises database instances 304B andcommon cache instance 306B.

At least some of the database instances executing on different computingdevices manage the same database and are communicatively connected overa SAN or a NAS network to storage device(s) that store the datacomprising this database. For example, as illustrated in FIG. 3,database instance 304A-2 (on computing device 304A) and databaseinstance 304B-1 (on computing device 304B) manage the same database“DB2”. The data comprising database “DB2” is stored across network 300on storage devices 310 that comprise disks 310A, 310B, and 310C. It isnoted that in FIG. 3, other database instances such as database instance304A-1 (on computing device 304A) and database instance 304B-2 (oncomputing device 304B) may be configured to manage databases whose datais also stored across network 300 on storage devices 310 or on otherstorage devices that are connected to network 300.

According to the techniques described herein, the common caches managedby the common cache instances on computing devices 302 are organized tooperate in a cluster. Each of the common cache instances in the clusterincludes one or more processes that are configured to request datablocks from other common cache instances in the cluster and to send datablocks to the other common cache instances in response to requeststherefrom.

As an operational example, consider a scenario where database instance304A-2 on computing device 304A needs to retrieve into its private cachea particular data block (e.g., such as a data block 43 from data file2). Database instance 304A-2 sends a request for this data block to itslocal common cache instance 306A. Common cache instance 306A searchesthe common cache allocated on computing device 302A and determines thatthe requested data block (e.g., data block 43 from data file 2) is notstored therein. Instead of returning a cache miss indication to databaseinstance 304A-2, common cache instance 306A sends a request for thisdata block to another common cache instance in the cluster. For example,in some implementations common cache instance 306A may send a broadcastrequest to all computing devices which run a database instance thatmanages the same database (“DB2”) as database instance 304A-2; in otherimplementations, common cache instance 306A may query a cluster-widedata directory to determine which common cache instance in the clusterstores the requested data block. Suppose that common cache instance 306Bon computing device 302B stores in its common cache the requested datablock (e.g., data block 43 from data file 2) because database instance304B-1 (which manages the same database “DB2”) has placed it there. Inresponse to the request from common cache instance 306A, common cacheinstance 306B retrieves the requested data block from its common cacheand sends the data block to common cache instance 306A. In response toreceiving the requested data block, common cache instance 306A mayperform some validity checks to determine whether the received datablock is the most current copy of the data block and, if so, may returnthe data block to database instance 304A-2 that requested it. (It isnoted that based on the particular implementation, common cache 306A mayor may not store the received data block in its common cache; one reasonfor not storing it may be based on an anticipation that the databaseinstance will soon modify the data block, thereby obviating the need tokeep the soon-to-be-dirty data block in the common cache.) In thismanner, database instance 304A-2 succeeds in obtaining the data block itneeds (e.g., data block 43 from data file 2) without performing any I/Ooperations to retrieve the data block from storage devices 310.

Various embodiments may use various data transfer mechanisms that aresuitable for transferring data blocks between multiple common cacheinstances that are configured in a cluster. Based on the particulardeployment characteristics, such data transfer mechanisms may bedeployed over one or more networks to which the computing devicesrunning the common cache instances are connected, over point-to-pointbi-directional links between the computing devices, and/or over anyother suitable connectivity paradigm that allows for inter-processcommunications.

In some embodiments, the common cache instances in the cluster maymaintain a global data directory which indicates which data blocks arestored in which common caches. For example, each of the common cacheinstances may include one or more processes that are tasked withmaintaining, in a distributed global directory, a current mapping thatmaps data block identifier(s) to the common cache instances whichcurrently store the data block(s) identified by these data blockidentifier(s). In addition, in these embodiments the common cacheinstances may use a global mapping that maps each data block stored in acommon cache to a unique cluster-wide ID, where the common cacheinstances may propagate to each other any newly assigned uniquecluster-wide IDs and use the unique cluster-wide IDs to request datablocks from each other.

In some deployments, the use of a common cache cluster in accordancewith the techniques described herein provides for better availabilitythan would be possible by using conventional approaches. For example, acomputing device may be designated as the primary host for a givendatabase, e.g., database “DB1”, and may be designated as the secondaryhost for one or more other databases, e.g., databases “DB2”, “DB3”, etc.On this computing device, the database instance managing database “DB1”may be allocated a bigger chunk of the volatile memory of the computingdevice for its private cache, while the database instances that managethe other databases (e.g., databases “DB2”, “DB3”, etc.) may beallocated smaller chunks of volatile memory for their private caches.The technical effect of this type of deployment would be that, for eachdatabase, a database instance on a primary host will have a biggerprivate cache to store data blocks from that database, while one or moredatabase instances on one or more secondary hosts will have smallerprivate caches for storing data blocks from that database. Sinceaccording to the techniques described herein a common cache on theprimary host will store clean data blocks from the database and sincethe common caches on the primary host and secondary host(s) of thedatabase are integrated into a cluster, the availability of the databaseis increased because when the database instance on the primary hostfails over to a database instance on a secondary host, the common cacheinstance on the secondary host can fetch the clean data blocks for thedatabase from the common cache on the primary host without the need toperform expensive I/O operations and without the need to re-provisionmemory from other instances that run on the secondary host.

By providing for integration of multiple common caches on multiplecomputing devices into a cluster, the techniques described herein allowfor achieving linear scalability of database instances on a large scale.In addition, the techniques described herein allow for more flexibledeployments that provide for better availability by using a deploymentscheme in which a database instance on a computing device, which isdesignated as a primary host for a given database, is configureddifferently than one or more other database instances on one or moreother computing devices, which are designated as secondary hosts for thegiven database.

Use Case: Warming Up the Private Cache Upon Instance Restart

In some operational contexts, the techniques for universal cachemanagement described herein provide for efficient warm-up of the privatecache of a database instance when the database instances restarts.

According to the techniques described herein, a common cache on acomputing device is configured to keep data blocks in the common cacheacross restarts of the database instances that placed these data blocksinto the common cache. The instance or processes thereof that manage thecommon cache can preserve the data blocks across database instancerestarts because block-identifying data for the data blocks is alsomaintained in the common cache, thereby providing higher visibility ofthe block usage by the database instances. Thus, when a databaseinstance restarts, the database instance can retrieve from the commoncache into its private cache the clean and current data blocks that werepreviously placed into the common cache. The technical effect of thiswould be that the restarting database instance will reach a normaloperating state a lot faster than would be possible if the restartingdatabase instance populates its private cache in a conventional way(which involves retrieving a data block from persistent storage onlywhen access to the data in the data block is requested by a client or anapplication) because the restarting database instance will not need toperform computationally expensive I/O operations to fetch data blocksfrom the persistent storage.

For example, in some embodiments an instance or a process thereof thatmanages the common cache maintains, for each data block stored in thecommon cache, a lock incarnation number and/or a SCN that is associatedwith that data block by the database instance that uses the block. Sincethe lock incarnation number and/or the SCN are persistent attributesthat are stored on persistent storage (as opposed to run-timeattributes, such as an OS process ID, that change each time a databaseinstance is restarted), the instance managing the common cache has agreater visibility into the usage of the data block by the databaseinstance. Thus, when the database instance restarts, the databaseinstance knows what lock incarnation numbers and/or SCN to expect, andas a result the database instance can retrieve those data blocks fromthe common cache that have the expected lock incarnation numbers and/orSCN, thereby ensuring that “expired” copies of data blocks will not beread into the private cache of the database instance upon restart.

Further, this ability of a restarting database instance to warm-up itsprivate cache by reading data blocks from the common cache is veryuseful in reducing the downtime that is incurred when the databaseinstances in a cluster need to undergo a software upgrade. In a typicalcluster deployment, software upgrades are a difficult and time-consumingtask. A typical software upgrade of a cluster involves upgradingdatabase instances and/or processes and services thereof across allnodes in the cluster and restarting these instances and/or processes andservices thereof. For a distributed system in which the private cachesof many database instances collectively sum to a large size, this meansthat after a software upgrade this large-sized collective cache needs tobe warmed up in order to provide full availability of database instancecluster in a short time. Clearly, by using the conventional way topopulate private caches, each database instance in the cluster needs toindividually warm up its private cache before being able to take on itsexpected full workload. However, according to the techniques describedherein, the downtimes caused by software upgrades are much shorterbecause each database instance in the cluster can warm-up its privatecache by reading data blocks from its local common cache (and/or fromthe common cache cluster, if the common caches in the distributed systemare configured as a cluster) because the local cache (and/or the commoncache cluster) is likely to store most of the data blocks that areneeded by each individual database instance to assume its full workload.

Hardware Overview

According to one embodiment, the techniques described herein areimplemented by one or more special-purpose computing devices. Thespecial-purpose computing devices may be hard-wired to perform thetechniques, or may include digital electronic devices such as one ormore application-specific integrated circuits (ASICs) or fieldprogrammable gate arrays (FPGAs) that are persistently programmed toperform the techniques, or may include one or more general purposehardware processors programmed to perform the techniques pursuant toprogram instructions in firmware, memory, other storage, or acombination. Such special-purpose computing devices may also combinecustom hard-wired logic, ASICs, or FPGAs with custom programming toaccomplish the techniques. The special-purpose computing devices may beSMP machines, server computer systems, desktop or portable computersystems, network infrastructure devices, or any other device (e.g., suchas a blade) that incorporates hard-wired and/or program logic toimplement the techniques.

For example, FIG. 4 is a block diagram that illustrates a computersystem 400 upon which an embodiment of the techniques described hereinmay be implemented. Computer system 400 includes a bus 402 or othercommunication mechanism for communicating information, and a hardwareprocessor 404 coupled with bus 402 for processing information. Hardwareprocessor 404 may be, for example, a general purpose microprocessor.

Computer system 400 also includes a main memory 406, such as a randomaccess memory (RAM) or other dynamic storage device (e.g., such as flashmemory card), coupled to bus 402 for storing information andinstructions to be executed by processor 404. Main memory 406 also maybe used for storing temporary variables or other intermediateinformation during execution of instructions to be executed by processor404. Such instructions, when stored in non-transitory storage mediaaccessible to processor 404, render computer system 400 into aspecial-purpose machine that is customized to perform the operationsspecified in the instructions.

Computer system 400 further includes a read only memory (ROM) 408 orother static storage device coupled to bus 402 for storing staticinformation and instructions for processor 404. A storage device 410,such as a magnetic disk or optical disk, is provided and coupled to bus402 for storing information and instructions.

Computer system 400 may be coupled via bus 402 to a display 412, such asa cathode ray tube (CRT) or a liquid crystal display (LCD), fordisplaying information to a computer user. An input device 414,including alphanumeric and other keys, is coupled to bus 402 forcommunicating information and command selections to processor 404.Another type of user input device is cursor control 416, such as amouse, a trackball, or cursor direction keys for communicating directioninformation and command selections to processor 404 and for controllingcursor movement on display 412. This input device typically has twodegrees of freedom in two axes, a first axis (e.g., x) and a second axis(e.g., y), that allows the device to specify positions in a plane.

Computer system 400 may implement the techniques for universal cachemanagement described herein by using customized hard-wired logic, one ormore ASICs or FPGAs, firmware and/or program logic which in combinationwith the computer system causes or programs computer system 400 to be aspecial-purpose machine. According to one embodiment, the techniquesherein are performed by computer system 400 in response to processor 404executing one or more sequences of one or more instructions contained inmain memory 406. Such instructions may be read into main memory 406 fromanother storage medium, such as storage device 410. Execution of thesequences of instructions contained in main memory 406 causes processor404 to perform the process steps described herein. In alternativeembodiments, hard-wired circuitry may be used in place of or incombination with software instructions.

The term “storage media” as used herein refers to any non-transitorymedia that store data and/or instructions that cause a machine tooperate in a specific fashion. Such storage media may comprisenon-volatile media and/or volatile media. Non-volatile media includes,for example, optical or magnetic disks, such as storage device 410.Volatile media includes dynamic memory, such as main memory 406, flashmemory, and/or a combination thereof. Common forms of storage mediainclude, for example, a floppy disk, a flexible disk, hard disk, solidstate drive, magnetic tape, or any other magnetic data storage medium, aCD-ROM, any other optical data storage medium, any physical medium withpatterns of holes, a RAM, a PROM, and EPROM, a FLASH-EPROM, NVRAM, anyother memory chip or cartridge.

Storage media is distinct from but may be used in conjunction withtransmission media. Transmission media participates in transferringinformation between storage media. For example, transmission mediaincludes coaxial cables, copper wire and fiber optics, including thewires that comprise bus 402. Transmission media can also take the formof acoustic or light waves, such as those generated during radio-waveand infra-red data communications.

Various forms of media may be involved in carrying one or more sequencesof one or more instructions to processor 404 for execution. For example,the instructions may initially be carried on a magnetic disk or solidstate drive of a remote computer. The remote computer can load theinstructions into its dynamic memory and send the instructions over atelephone line using a modem. A modem local to computer system 400 canreceive the data on the telephone line and use an infra-red transmitterto convert the data to an infra-red signal. An infra-red detector canreceive the data carried in the infra-red signal and appropriatecircuitry can place the data on bus 402. Bus 402 carries the data tomain memory 406, from which processor 404 retrieves and executes theinstructions. The instructions received by main memory 406 mayoptionally be stored on storage device 410 either before or afterexecution by processor 404.

Computer system 400 also includes a communication interface 418 coupledto bus 402. Communication interface 418 provides a two-way datacommunication coupling to a network link 420 that is connected to alocal network 422. For example, communication interface 418 may be anintegrated services digital network (ISDN) card, cable modem, satellitemodem, or a modem to provide a data communication connection to acorresponding type of telephone line. As another example, communicationinterface 418 may be a local area network (LAN) card to provide a datacommunication connection to a compatible LAN. Wireless links may also beimplemented. In any such implementation, communication interface 418sends and receives electrical, electromagnetic or optical signals thatcarry digital data streams representing various types of information.

Network link 420 typically provides data communication through one ormore networks to other data devices. For example, network link 420 mayprovide a connection through local network 422 to a host computer 424 orto data equipment operated by an Internet Service Provider (ISP) 426.ISP 426 in turn provides data communication services through the worldwide packet data communication network now commonly referred to as the“Internet” 428. Local network 422 and Internet 428 both use electrical,electromagnetic or optical signals that carry digital data streams. Thesignals through the various networks and the signals on network link 420and through communication interface 418, which carry the digital data toand from computer system 400, are example forms of transmission media.

Computer system 400 can send messages and receive data, includingprogram code, through the network(s), network link 420 and communicationinterface 418. In the Internet example, a server 430 might transmit arequested code for an application program through Internet 428, ISP 426,local network 422 and communication interface 418.

The received code may be executed by processor 404 as it is received,and/or stored in storage device 410, or other non-volatile storage forlater execution.

In the foregoing specification, embodiments of the invention have beendescribed with reference to numerous specific details that may vary fromimplementation to implementation. The specification and drawings are,accordingly, to be regarded in an illustrative rather than a restrictivesense. The sole and exclusive indicator of the scope of the invention,and what is intended by the applicants to be the scope of the invention,is the literal and equivalent scope of the set of claims that issue fromthis application, in the specific form in which such claims issue,including any subsequent correction.

What is claimed is:
 1. A method comprising: allocating, in volatilememory of a Symmetric Multi Processor (SMP) machine, a first cacheexclusively to a first instance of two or more data-processinginstances, wherein the first cache is configured to store copies of afirst set of data blocks that are persistently stored on one or morestorage devices, and wherein the allocating the first cache isperformed, at least in part, by an operating system (OS) instance;allocating, in the same volatile memory of the SMP machine, a secondcache exclusively to a second instance of the two or moredata-processing instances, wherein the second cache is configured tostore copies of a second set of data blocks that are persistently storedon the one or more storage devices, and wherein the allocating thesecond cache is performed, at least in part, by the OS instance;allocating at least a portion of a common cache in the same volatilememory of the SMP machine, wherein the allocating at least a portion ofthe common cache is performed, at least in part, by the OS instance; thefirst instance performing the steps of: identifying for eviction fromthe first cache a first data block at least because the first data blockhas not been changed since the first data block was last persistentlywritten to the one or more storage devices; in response to identifyingfor eviction from the first cache a first data block at least becausethe first data block has not been changed since the first data block waslast persistently written to the one or more storage devices: causingthe first data block to be stored in the common cache, and removing thefirst data block from the first cache; the second instance performingthe steps of: identifying for eviction from the second cache a seconddata block at least because the second data block has not been changedsince the second data block was last persistently written to the one ormore storage devices: in response to identifying for eviction from thesecond cache a second data block at least because the second data blockhas not been changed since the second data block was last persistentlywritten to the one or more storage devices: causing the second datablock to be stored in the common cache, and removing the second datablock from the second cache; maintaining data blocks, including thefirst data block and the second data block, in the common cache withoutpersistently writing the data blocks to the one or more storage devices;and wherein the method is performed by the SMP machine.
 2. The method ofclaim 1, wherein the two or more data-processing instances are two ormore database instances that manage one or more databases that arestored on the one or more storage devices.
 3. The method of claim 1,wherein allocating at least a portion of the common cache comprises oneor more of: allocating the common cache in physical memory of the SMPmachine; and allocating a first portion of the common cache on thephysical memory of the SMP machine and a second portion of the commoncache on a flash memory that is attached to the SMP machine.
 4. Themethod of claim 1, wherein maintaining the data blocks in the commoncache comprises maintaining block-identifying data for each of the datablocks stored in the common cache.
 5. The method of claim 1, whereinmaintaining the data blocks in the common cache comprises: maintainingthe first data block in the common cache across a restart of the firstinstance; and maintaining the second data block in the common cacheacross a restart of the second instance.
 6. The method of claim 1,further comprising: in response to a first request for data from thefirst data block, the first instance retrieving the first data blockfrom the common cache instead of the one or more storage devices, andstoring the first data block back into the first cache; in response to asecond request for data from the second data block, the second instanceretrieving the second data block from the common cache instead of theone or more storage devices, and storing the second data block back intothe second cache.
 7. The method of claim 1, further comprising: inresponse to a request for data from the second data block, the firstinstance retrieving the second data block from the common cache insteadof the one or more storage devices, and storing the second data blockinto the first cache.
 8. The method of claim 1, further comprising: thefirst instance sending a request for a third data block to an instancethat manages the common cache; the instance that manages the commoncache performing the steps of: determining that the third data block isnot stored in the common cache; retrieving the third data block from adifferent common cache that is allocated on a different SMP machine; andreturning the third data block to the first instance.
 9. The method ofclaim 1, further comprising: the first instance requesting the firstdata block from the common cache; determining that the first data blockis not stored in the common cache; and retrieving the first data blockfrom the one or more storage devices, wherein retrieving the first datablock comprises one of: the first instance retrieving the first datablock from the one or more storage devices; or an instance that managesthe common cache retrieving the first data block from the one or morestorage devices and returning the first data block to the firstinstance.
 10. The method of claim 1, further comprising: after the firstinstance restarts, the first instance warming up the first cache byretrieving at least the first data block from the common cache insteadof the one or more storage devices and storing the first data block backinto the first cache; and after the second instance restarts, the secondinstance warming up the second cache by retrieving at least the seconddata block from the common cache instead of the one or more storagedevices and storing the second data block back into the second cache.11. The method of claim 1, wherein the common cache comprises a thirdset of clean data blocks that are persistently stored on one or morestorage devices, and wherein each particular clean data block of thethird set of clean data blocks not been changed since the particularclean data block was last persistently written to the one or morestorage devices.
 12. The method of claim 1, wherein allocating the firstcache comprises: allocating, by the OS instance, a first range of memoryaddresses to the first instance; allocating, by the first instance, asubset of the first range of memory addresses to the first cache; andwherein allocating the second cache comprises: allocating, by the OSinstance, a second range of memory addresses to the second instance;allocating, by the second instance, a subset of the second range ofmemory addresses to the second cache.
 13. The method of claim 1, whereinallocating the first cache comprises allocating, by the OS instance, afirst range of memory addresses to the first cache and whereinallocating the second cache comprises allocating, by the OS instance, asecond range of memory addresses to the second cache.
 14. A methodcomprising: allocating, in volatile memory of a computing device, aplurality of caches to a plurality of database instances, wherein eachone of the plurality of caches is exclusively allocated to a separatedatabase instance of said plurality of database instances to change datablocks stored in said each one of said plurality of caches that aremodified by a transaction, wherein the allocating the plurality ofcaches to a plurality of database instances is performed, at least inpart, by an operating system (OS) instance; allocating, in the samevolatile memory of the computing device, at least a portion of a commoncache that is shared by the plurality of database instances, wherein theallocating at least a portion of the common cache is performed, at leastin part, by the OS instance; each particular database instance, of theplurality of database instances, performing the steps of: identifying aparticular data block for eviction from a particular cache, of theplurality of caches, that is exclusively allocated to the particulardatabase instance, wherein the particular data block is identified forsaid eviction at least because the particular data block has not beenchanged in the particular cache since the particular data block was lastpersistently written to one or more storage devices; in response toidentifying a particular data block for eviction from a particularcache, of the plurality of caches, that is exclusively allocated to theparticular database instance: causing the particular data block to bestored in the common cache, and removing the particular data block fromthe particular cache; maintaining data blocks, including the particulardata block, in the common cache without persistently writing the datablocks to the one or more storage devices; wherein the method isperformed by the computing device.
 15. The method of claim 14, wherein:the particular database instance causing the particular data block to bestored in the common cache comprises one of: the particular databaseinstance storing the particular data block in the common cache; or theparticular database instance sending the particular data block to aninstance that manages the common cache.
 16. The method of claim 14,wherein: the particular database instance causing the particular datablock to be stored in the common cache comprises sending the particulardata block to an instance that manages the common cache; and theinstance that manages the common cache performing the steps of: storingthe particular data block in the common cache; assigning a particularidentifier to the particular data block, wherein the particularidentifier uniquely identifies the particular data block in the commoncache; returning the particular identifier to the particular databaseinstance.
 17. The method of claim 16, further comprising the particulardatabase instance storing the particular identifier in a particular lockstructure that is associated with the particular data block.
 18. Themethod of claim 16, further comprising: the particular database instanceretrieving the particular data block from the common cache and storingthe particular data block back into the particular cache, whereinretrieving the particular data block includes sending the particularidentifier to the instance that manages the common cache.
 19. The methodof claim 14, wherein the common cache comprises a set of clean datablocks that are persistently stored on one or more storage devices, andwherein each particular clean data block of the set of clean data blocksnot been changed since the particular clean data block was lastpersistently written to the one or more storage devices.
 20. Anon-transitory computer-readable storage medium storing one or moresequences of instructions which, when executed by one or moreprocessors, cause: allocating, in volatile memory of a Symmetric MultiProcessor (SMP) machine, a first cache exclusively to a first instanceof two or more data-processing instances, wherein the first cache isconfigured to store copies of a first set of data blocks that arepersistently stored on one or more storage devices, and wherein the oneor more sequences of instructions for allocating the first cache areperformed, at least in part, by an operating system (OS) instancerunning on the one or more processors; allocating, in the same volatilememory of the SMP machine, a second cache exclusively to a secondinstance of the two or more data-processing instances, wherein thesecond cache is configured to store copies of a second set of datablocks that are persistently stored on the one or more storage devices,and wherein the one or more sequences of instructions for allocating thesecond cache are performed, at least in part, by the OS instance;allocating at least a portion of a common cache in the same volatilememory of the SMP machine, wherein the one or more sequences ofinstructions for allocating at least a portion of the common cache areperformed, at least in part, by the OS instance; the first instanceperforming the steps of: identifying for eviction from the first cache afirst data block at least because the first data block has not beenchanged since the first data block was last persistently written to theone or more storage devices; in response to identifying for evictionfrom the first cache a first data block at least because the first datablock has not been changed since the first data block was lastpersistently written to the one or more storage devices: causing thefirst data block to be stored in the common cache, and removing thefirst data block from the first cache; the second instance performingthe steps of: identifying for eviction from the second cache a seconddata block at least because the second data block has not been changedsince the second data block was last persistently written to the one ormore storage devices: in response to identifying for eviction from thesecond cache a second data block at least because the second data blockhas not been changed since the second data block was last persistentlywritten to the one or more storage devices: causing the second datablock to be stored in the common cache, and removing the second datablock from the second cache; and maintaining data blocks, including thefirst data block and the second data block, in the common cache withoutpersistently writing the data blocks to the one or more storage devices.21. The non-transitory computer-readable storage medium of claim 20,wherein the two or more data-processing instances are two or moredatabase instances that manage one or more databases that are stored onthe one or more storage devices.
 22. The non-transitorycomputer-readable storage medium of claim 20, wherein allocating atleast a portion of the common cache comprises one or more of: allocatingthe common cache in physical memory of the SMP machine; and allocating afirst portion of the common cache on the physical memory of the SMPmachine and a second portion of the common cache on a flash memory thatis attached to the SMP machine.
 23. The non-transitory computer-readablestorage medium of claim 20, wherein maintaining the data blocks in thecommon cache comprises maintaining block-identifying data for each ofthe data blocks stored in the common cache.
 24. The non-transitorycomputer-readable storage medium of claim 20, wherein maintaining thedata blocks in the common cache comprises: maintaining the first datablock in the common cache across a restart of the first instance; andmaintaining the second data block in the common cache across a restartof the second instance.
 25. The non-transitory computer-readable storagemedium of claim 20, wherein the one or more sequences of instructionsinclude instructions that, when executed by one or more processors,cause: in response to a first request for data from the first datablock, the first instance retrieving the first data block from thecommon cache instead of the one or more storage devices, and storing thefirst data block back into the first cache; in response to a secondrequest for data from the second data block, the second instanceretrieving the second data block from the common cache instead of theone or more storage devices, and storing the second data block back intothe second cache.
 26. The non-transitory computer-readable storagemedium of claim 20, wherein the one or more sequences of instructionsinclude instructions that, when executed by one or more processors,cause: in response to a request for data from the second data block, thefirst instance retrieving the second data block from the common cacheinstead of the one or more storage devices, and storing the second datablock into the first cache.
 27. The non-transitory computer-readablestorage medium of claim 20, wherein the one or more sequences ofinstructions include instructions that, when executed by one or moreprocessors, cause: the first instance sending a request for a third datablock to an instance that manages the common cache; the instance thatmanages the common cache performing the steps of: determining that thethird data block is not stored in the common cache; retrieving the thirddata block from a different common cache that is allocated on adifferent SMP machine; and returning the third data block to the firstinstance.
 28. The non-transitory computer-readable storage medium ofclaim 20, wherein the one or more sequences of instructions includeinstructions that, when executed by one or more processors, cause: thefirst instance requesting the first data block from the common cache;determining that the first data block is not stored in the common cache;and retrieving the first data block from the one or more storagedevices, wherein retrieving the first data block comprises one of: thefirst instance retrieving the first data block from the one or morestorage devices; or an instance that manages the common cache retrievingthe first data block from the one or more storage devices and returningthe first data block to the first instance.
 29. The non-transitorycomputer-readable storage medium of claim 20, wherein the one or moresequences of instructions include instructions that, when executed byone or more processors, cause: after the first instance restarts, thefirst instance warming up the first cache by retrieving at least thefirst data block from the common cache instead of the one or morestorage devices and storing the first data block back into the firstcache; and after the second instance restarts, the second instancewarming up the second cache by retrieving at least the second data blockfrom the common cache instead of the one or more storage devices andstoring the second data block back into the second cache.
 30. Thenon-transitory computer-readable storage medium of claim 20, wherein thecommon cache comprises a third set of clean data blocks that arepersistently stored on one or more storage devices, and wherein eachparticular clean data block of the third set of clean data blocks notbeen changed since the particular clean data block was last persistentlywritten to the one or more storage devices.
 31. The non-transitorycomputer-readable storage medium of claim 20, wherein allocating thefirst cache comprises: allocating, by the OS instance, a first range ofmemory addresses to the first instance; allocating, by the firstinstance, a subset of the first range of memory addresses to the firstcache; and wherein allocating the second cache comprises: allocating, bythe OS instance, a second range of memory addresses to the secondinstance; allocating, by the second instance, a subset of the secondrange of memory addresses to the second cache.
 32. The non-transitorycomputer-readable storage medium of claim 20, wherein allocating thefirst cache comprises allocating, by the OS instance, a first range ofmemory addresses to the first cache and wherein allocating the secondcache comprises allocating, by the OS instance, a second range of memoryaddresses to the second cache.
 33. A non-transitory computer-readablestorage medium storing one or more sequences of instructions which, whenexecuted by one or more processors, cause: allocating, in volatilememory of a computing device, a plurality of caches to a plurality ofdatabase instances, wherein each one of the plurality of caches isexclusively allocated to a separate database instance of said pluralityof database instances to change data blocks stored in said each one ofsaid plurality of caches that are modified by a transaction, and whereinthe one or more sequences of instructions for allocating the pluralityof caches are performed, at least in part, by an operating system (OS)instance running on the one or more processors; allocating, in the samevolatile memory of the computing device, at least a portion of a commoncache that is shared by the plurality of database instances, and whereinthe one or more sequences of instructions for allocating at least aportion of the common cache are performed, at least in part, by theoperating system; each particular database instance, of the plurality ofdatabase instances, performing the steps of: identifying a particulardata block for eviction from a particular cache, of the plurality ofcaches, that is exclusively allocated to the particular databaseinstance, wherein the particular data block is identified for saideviction at least because the particular data block has not been changedin the particular cache since the particular data block was lastpersistently written to one or more storage devices; in response toidentifying a particular data block for eviction from a particularcache, of the plurality of caches, that is exclusively allocated to theparticular database instance: causing the particular data block to bestored in the common cache, and removing the particular data block fromthe particular cache; and maintaining data blocks, including theparticular data block, in the common cache without persistently writingthe data blocks to the one or more storage devices.
 34. Thenon-transitory computer-readable storage medium of claim 33, wherein:the particular database instance causing the particular data block to bestored in the common cache comprises one of: the particular databaseinstance storing the particular data block in the common cache; or theparticular database instance sending the particular data block to aninstance that manages the common cache.
 35. The non-transitorycomputer-readable storage medium of claim 33, wherein: the particulardatabase instance causing the particular data block to be stored in thecommon cache comprises sending the particular data block to an instancethat manages the common cache; and the instance that manages the commoncache performing the steps of: storing the particular data block in thecommon cache; assigning a particular identifier to the particular datablock, wherein the particular identifier uniquely identifies theparticular data block in the common cache; returning the particularidentifier to the particular database instance.
 36. The non-transitorycomputer-readable storage medium of claim 35, the instructions furthercomprising instructions for the particular database instance storing theparticular identifier in a particular lock structure that is associatedwith the particular data block.
 37. The non-transitory computer-readablestorage medium of claim 36, the instructions further comprisinginstructions for: the particular database instance retrieving theparticular data block from the common cache and storing the particulardata block back into the particular cache, wherein retrieving theparticular data block includes sending the particular identifier to theinstance that manages the common cache.
 38. The non-transitorycomputer-readable storage medium of claim 33, wherein the common cachecomprises a set of clean data blocks that are persistently stored on oneor more storage devices, and wherein each particular clean data block ofthe set of clean data blocks not been changed since the particular cleandata block was last persistently written to the one or more storagedevices.